-- Unlock a user ALTER USER my_user ACCOUNT UNLOCK; -- If password is expired ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;